{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hidden Data","Hidden Controls","Rate Convector"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hidden Data","index":0,"n_rows":285,"n_cols":34,"rows_kept":285,"cut":false,"hidden":true,"merged":[[96,17,96,27],[97,17,97,27],[98,18,98,26],[99,18,100,19],[96,2,96,12],[97,2,97,12],[99,3,100,4],[98,3,98,11]]}
[]
[null,null,null,"CONVECTOR STEAM RATINGS"]
[null,null,null,null,null,null,null,"STEAM RATINGS IN EDR (215° AT 65° E.A.T.)"]
[null,null,null,null,null,null,"group 1",null,null,null,null,null,null,null,"group 2",null,null,null,null,null,null,null,"group 3",null,null,null,null,null,null,null,"group 4"]
[null,null,null,null,null,"FRONT OUTLET, NOMINAL LINER HEIGHT",null,null,null,null,null,null,null,"FRONT OUTLET, WALL MOUNTED, NOM. HEIGHT",null,null,null,null,null,null,null,"SLOPE TOP, FREE STANDING, NOMINAL HEIGHT",null,null,null,null,null,null,null,"SLOPE TOP, WALL MOUNTED, NOMINAL HEIGHT"]
[null,null,"DEPTH   IN   INCHES","LENGTH  IN  INCHES",null,"*TYPES FS-A, FSG-A, SR-A, SRG-A, RF-A, RFG-A, PW-A, PWG-A, FWG-A",null,null,null,null,null,null,null,"TYPE W-A",null,null,null,null,null,null,null,"*TYPE SF-A, SFG-A",null,null,null,null,null,null,null,"TYPE SW-A"]
[null,null,null,null,null,"18\"","20\"","20\"","26\"","32\"",null,null,null,"14\"","18\"","20\"","26\"","32\"",null,null,null,"18\"","20\"","24\"","26\"","32\"",null,null,null,"14\"","18\"","20\"","26\"","32\""]
[null,null,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5]
[null,null,"4 (1)",20,1,9.3000000000000007,10.4,11.8,12.2,13,null,null,null,10.4,11.8,12.200000000000001,13,13.6,null,null,1,11.7,12.200000000000001,13,13.4,13.9,null,null,1,12.200000000000001,13,13.4,13.9,14.6]
[null,null,null,24,2,11.5,13.100000000000001,15.1,15.5,16.600000000000001,null,null,null,13.100000000000001,15.100000000000001,15.5,16.600000000000001,17.3,null,null,2,15,15.5,16.5,17,17.7,null,null,2,15.5,16.5,17,17.7,18.399999999999999]
[null,null,null,28,3,13.8,15.9,18.100000000000001,18.600000000000001,19.899999999999999,null,null,null,15.9,18.100000000000001,18.600000000000001,19.900000000000002,21,null,null,3,18,18.7,19.900000000000002,20.400000000000002,21.3,null,null,3,18.7,19.900000000000002,20.400000000000002,21.3,22.1]
[null,null,null,32,4,16.100000000000001,18.7,21.3,21.9,23.6,null,null,null,18.7,21.3,21.900000000000002,23.6,24.8,null,null,4,21.3,22.1,23.5,24,25.200000000000003,null,null,4,22.1,23.5,24,25.200000000000003,26.2]
[null,null,null,36,5,18.2,21.5,24.5,25.1,27.1,null,null,5,21.5,24.5,25.1,27.1,28.6,null,null,5,24.6,25.3,26.900000000000002,27.6,29,null,null,5,25.3,26.900000000000002,27.6,29,30.2]
[null,null,null,40,6,20.399999999999999,24.200000000000003,27.5,28.3,30.5,null,null,6,24.200000000000003,27.5,28.3,30.5,32.200000000000003,null,null,6,27.7,28.5,30.5,31.3,32.700000000000003,null,null,6,28.5,30.5,31.3,32.700000000000003,33.799999999999997]
[null,null,null,44,7,22.6,27,30.8,31.5,34,null,null,7,27,30.8,31.5,34,36,null,null,7,30.6,31.8,33.9,34.800000000000004,36.4,null,null,7,31.8,33.9,34.800000000000004,36.4,37.799999999999997]
[null,null,null,48,8,24.8,29.6,33.800000000000004,34.800000000000004,37.4,null,null,8,29.6,33.800000000000004,34.800000000000004,37.4,39.700000000000003,null,null,8,33.9,35,37.4,38.300000000000004,40.1,null,null,8,35,37.4,38.300000000000004,40.1,41.6]
[null,null,null,52,9,27.3,32.5,36.9,37.800000000000004,40.6,null,null,9,32.5,36.9,37.800000000000004,40.6,43.1,null,null,9,36.799999999999997,38.1,40.6,41.400000000000006,43.5,null,null,9,38.1,40.6,41.400000000000006,43.5,45.2]
[null,null,null,56,10,29.3,35.200000000000003,40.1,41.1,44.300000000000004,null,null,10,35.200000000000003,40.1,41.1,44.300000000000004,47.1,null,null,10,40.1,41.400000000000006,44.400000000000006,45.2,47.5,null,null,10,41.400000000000006,44.400000000000006,45.2,47.5,49.3]
[null,null,null,60,11,31.9,38,43.1,44.2,47.5,null,null,11,38,43.1,44.2,47.5,50.5,null,null,11,42.7,44.6,47.5,48.400000000000006,50.800000000000004,null,null,11,44.6,47.5,48.400000000000006,50.800000000000004,53.4]
[null,null,null,64,12,33.9,40.800000000000004,46.400000000000006,47.5,51.2,null,null,12,40.800000000000004,46.400000000000006,47.5,51.2,54.5,null,null,12,45.8,47.900000000000006,51.300000000000004,52.2,54.800000000000004,null,null,12,47.900000000000006,51.300000000000004,52.2,54.800000000000004,58]
[]
[null,null,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5]
[null,null,"6 (2)",20,1,13.5,15.100000000000001,17.7,18.3,20.200000000000003,null,null,1,15.100000000000001,17.7,18.3,20.200000000000003,21,null,null,1,18.2,18.8,20.700000000000003,21.200000000000003,22.6,null,null,1,18.8,20.700000000000003,21.200000000000003,22.6,23.7]
[null,null,null,24,2,16.8,19,22.400000000000002,23.200000000000003,25.700000000000003,null,null,2,19,22.400000000000002,23.200000000000003,25.700000000000003,26.7,null,null,2,22.6,23.8,26.200000000000003,27,29,null,null,2,23.8,26.200000000000003,27,29,29.9]
[null,null,null,28,3,20.2,23,27,27.8,30.700000000000003,null,null,3,23,27,27.8,30.700000000000003,31.9,null,null,3,27.2,28.700000000000003,31.5,32.300000000000004,34.700000000000003,null,null,3,28.700000000000003,31.5,32.300000000000004,34.700000000000003,36.200000000000003]
[null,null,null,32,4,23.4,27,31.700000000000003,32.800000000000004,36.200000000000003,null,null,4,27,31.700000000000003,32.800000000000004,36.200000000000003,37.6,null,null,4,31.4,33.800000000000004,37.1,38,41,null,null,4,33.800000000000004,37.1,38,41,42.2]
[null,null,null,36,5,26.8,30.8,36.200000000000003,37.6,41.400000000000006,null,null,5,30.8,36.200000000000003,37.6,41.400000000000006,43.1,null,null,5,37.1,38.700000000000003,42.400000000000006,43.7,46.900000000000006,null,null,5,38.700000000000003,42.400000000000006,43.7,46.900000000000006,48.4]
[null,null,null,40,6,30.2,34.9,40.900000000000006,42.5,46.800000000000004,null,null,6,34.9,40.900000000000006,42.5,46.800000000000004,48.6,null,null,6,41.6,43.7,47.800000000000004,49.2,52.800000000000004,null,null,6,43.7,47.800000000000004,49.2,52.800000000000004,54.8]
[null,null,null,44,7,33.6,38.700000000000003,45.5,47.300000000000004,52,null,null,7,38.700000000000003,45.5,47.300000000000004,52,54.1,null,null,7,46.6,48.6,53.300000000000004,54.6,59,null,null,7,48.6,53.300000000000004,54.6,59,61.1]
[null,null,null,48,8,37,42.7,50.1,51.900000000000006,57.1,null,null,8,42.7,50.1,51.900000000000006,57.1,59.6,null,null,8,51.4,53.5,58.5,60.300000000000004,64.8,null,null,8,53.5,58.5,60.300000000000004,64.8,67.099999999999994]
[null,null,null,52,9,40.6,46.6,54.6,56.400000000000006,62.1,null,null,9,46.6,54.6,56.400000000000006,62.1,64.599999999999994,null,null,9,56.4,58.400000000000006,63.7,65.5,70.400000000000006,null,null,9,58.400000000000006,63.7,65.5,70.400000000000006,73.3]
[null,null,null,56,10,43.8,50.6,59.300000000000004,61.400000000000006,67.600000000000009,null,null,10,50.6,59.300000000000004,61.400000000000006,67.600000000000009,70.5,null,null,10,62.3,63.400000000000006,69.400000000000006,71.400000000000006,76.7,null,null,10,63.400000000000006,69.400000000000006,71.400000000000006,76.7,79.8]
[null,null,null,60,11,47.5,54.400000000000006,63.800000000000004,66,72.600000000000009,null,null,11,54.400000000000006,63.800000000000004,66,72.600000000000009,75.599999999999994,null,null,11,65.8,68.100000000000009,74.5,76.5,82.2,null,null,11,68.100000000000009,74.5,76.5,82.2,85.7]
[null,null,null,64,12,50.8,58.5,68.5,71.100000000000009,78.2,null,null,12,58.5,68.5,71.100000000000009,78.2,81.599999999999994,null,null,12,70.2,73.2,80.300000000000011,82.4,88.600000000000009,null,null,12,73.2,80.300000000000011,82.4,88.600000000000009,92]
[]
[null,null,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5,null,null,null,1,2,3,4,5]
[null,null,"8 (3)",20,1,16.8,18.900000000000002,21,21.400000000000002,23.200000000000003,null,null,1,18.900000000000002,21,21.400000000000002,23.200000000000003,24.2,null,null,1,22.9,24,25.5,26.3,28.200000000000003,null,null,1,24,25.5,26.3,28.200000000000003,29.3]
[null,null,null,24,2,21.3,24,26.5,27.400000000000002,29.6,null,null,2,24,26.5,27.400000000000002,29.6,31.1,null,null,2,30,30.6,32.6,33.5,36.1,null,null,2,30.6,32.6,33.5,36.1,37.5]
[null,null,null,28,3,26.6,29,32,32.9,35.5,null,null,3,29,32,32.9,35.5,37.200000000000003,null,null,3,36,37,39.200000000000003,40.200000000000003,43.400000000000006,null,null,3,37,39.200000000000003,40.200000000000003,43.400000000000006,45.1]
[null,null,null,32,4,31.5,34.1,37.6,38.800000000000004,41.900000000000006,null,null,4,34.1,37.6,38.800000000000004,41.900000000000006,44,null,null,4,42.6,43.5,46.400000000000006,47.5,51.300000000000004,null,null,4,43.5,46.400000000000006,47.5,51.300000000000004,53.3]
[null,null,null,36,5,36.299999999999997,39.1,43.300000000000004,44.6,48.1,null,null,5,39.1,43.300000000000004,44.6,48.1,50.5,null,null,5,49,50.2,55.2,54.6,58.900000000000006,null,null,5,50.2,55.2,54.6,58.900000000000006,61.2]
[null,null,null,40,6,41.1,44.300000000000004,49,50.300000000000004,54.400000000000006,null,null,6,44.300000000000004,49,50.300000000000004,54.400000000000006,56.9,null,null,6,55,56.5,60.1,61.800000000000004,66.600000000000009,null,null,6,56.5,60.1,61.800000000000004,66.600000000000009,69.099999999999994]
[null,null,null,44,7,46,49.300000000000004,54.400000000000006,56,60.6,null,null,7,49.300000000000004,54.400000000000006,56,60.6,63.3,null,null,7,61.6,63,66.8,68.8,74,null,null,7,63,66.8,68.8,74,76.8]
[null,null,null,48,8,49.8,53.900000000000006,60,61.7,67,null,null,8,53.900000000000006,60,61.7,67,70,null,null,8,68,69.5,73.8,74.600000000000009,81.7,null,null,8,69.5,73.8,74.600000000000009,81.7,84.9]
[null,null,null,52,9,56.1,59.300000000000004,65.3,67.100000000000009,72.600000000000009,null,null,9,59.300000000000004,65.3,67.100000000000009,72.600000000000009,75.599999999999994,null,null,9,73.8,75.8,80.2,82.300000000000011,88.9,null,null,9,75.8,80.2,82.300000000000011,88.9,92.6]
[null,null,null,56,10,60.9,64.600000000000009,71.2,73.2,79.2,null,null,10,64.600000000000009,71.2,73.2,79.2,82.7,null,null,10,80.7,82.300000000000011,87.5,89.800000000000011,96.9,null,null,10,82.300000000000011,87.5,89.800000000000011,96.9,100.9]
[null,null,null,60,11,65.7,69.400000000000006,76.400000000000006,78.5,84.9,null,null,11,69.400000000000006,76.400000000000006,78.5,84.9,88.4,null,null,11,86.4,88.7,93.800000000000011,96.300000000000011,104,null,null,11,88.7,93.800000000000011,96.300000000000011,104,108.5]
[null,null,null,64,12,69.900000000000006,74.5,82.300000000000011,84.7,91.5,null,null,12,74.5,82.300000000000011,84.7,91.5,95.4,null,null,12,93.3,95.4,101.10000000000001,103.9,112,null,null,12,95.4,101.10000000000001,103.9,112,116.7]
[]
[]
[null,null,null,"group1depth4rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!F8:J20,'Hidden Controls'!I4+1,FALSE)","v":9.3000000000000007},null,null,null,null,null,null,null,null,"group2depth4rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!N8:R20,'Hidden Controls'!I4+1,FALSE)","v":10.4},null,null,null,null,null,null,null,"group3depth4rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!V8:Z20,'Hidden Controls'!I4+1,FALSE)","v":11.7},null,null,null,null,null,"group4depth4rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!AD8:AH20,'Hidden Controls'!I4+1,FALSE)","v":12.200000000000001}]
[null,null,null,"group1depth6rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!F22:J34,'Hidden Controls'!I4+1,FALSE)","v":13.5},null,null,null,null,null,null,null,null,"group2depth6rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!N22:R34,'Hidden Controls'!I4+1,FALSE)","v":15.100000000000001},null,null,null,null,null,null,null,"group3depth6rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!V22:Z34,'Hidden Controls'!I4+1,FALSE)","v":18.2},null,null,null,null,null,"group4depth6rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!AD22:AH34,'Hidden Controls'!I4+1,FALSE)","v":18.8}]
[null,null,null,"group1depth8rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!F36:J48,'Hidden Controls'!I4+1,FALSE)","v":16.8},null,null,null,null,null,null,null,null,"group2depth8rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!N36:R48,'Hidden Controls'!I4+1,FALSE)","v":18.900000000000002},null,null,null,null,null,null,null,"group3depth8rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!V36:Z48,'Hidden Controls'!I4+1,FALSE)","v":22.9},null,null,null,null,null,"group4depth8rating=",{"$f":"HLOOKUP('Hidden Controls'!L4,'Hidden Data'!AD36:AH48,'Hidden Controls'!I4+1,FALSE)","v":24}]
[null,null,null,"group1selected depth rating =",{"$f":"IF('Hidden Controls'!F4=1,'Hidden Data'!E51,IF('Hidden Controls'!F4=2,'Hidden Data'!E52,'Hidden Data'!E53))","v":9.3000000000000007},null,null,null,null,null,null,null,null,"group2selected depth rating =",{"$f":"IF('Hidden Controls'!F4=1,'Hidden Data'!O51,IF('Hidden Controls'!F4=2,'Hidden Data'!O52,'Hidden Data'!O53))","v":10.4},null,null,null,null,null,null,null,"group3selected depth rating =",{"$f":"IF('Hidden Controls'!F4=1,'Hidden Data'!X51,IF('Hidden Controls'!F4=2,'Hidden Data'!X52,'Hidden Data'!X53))","v":11.7},null,null,null,null,null,"group4selected depth rating =",{"$f":"IF('Hidden Controls'!F4=1,'Hidden Data'!AE51,IF('Hidden Controls'!F4=2,'Hidden Data'!AE52,'Hidden Data'!AE53))","v":12.200000000000001}]
[]
[null,null,null,null,null,null,null,null,null,null,"unit specific rating (EDR) =",{"$f":"IF('Hidden Controls'!C4=13, 'Hidden Data'!O54,IF(OR('Hidden Controls'!C4=8,'Hidden Controls'!C4=9),'Hidden Data'!X54,IF('Hidden Controls'!C4=12,'Hidden Data'!AE54,'Hidden Data'!E54)))","v":9.3000000000000007}]
[]
[null,null,null,null,"Hot Water Correction Factors",null,null,null,null,null,null,"Steam Correction Factor"]
[null,null,null,"index",1,2,3,4,5,null,"index",1,2,3,4,5,6,7]
[null,null,"index",null,55,60,65,70,75,null,"psig",0.89900000000000002,5,10,15,20,25,50]
[null,null,1,100,0.17,0.14000000000000001,0.12,0.09,7.0000000000000007E-2,null,"factor",1,1.1200000000000001,1.25,1.36,1.46,1.56,1.93]
[null,null,2,110,0.23,0.2,0.17,0.14000000000000001,0.12]
[null,null,3,120,0.28999999999999998,0.26,0.23,0.2,0.17]
[null,null,4,130,0.35,0.32,0.28999999999999998,0.26,0.23,null,null,"interpolate value",{"$f":"'Rate Convector'!E18","v":0.89900000000000002}]
[null,null,5,140,0.43,0.39,0.35,0.32,0.28999999999999998,null,null,"FIND X INDEX",{"$f":"IF(MATCH(M64,'Hidden Data'!L60:R60,1)=7,6,MATCH(M64,'Hidden Data'!L60:R60,1))","v":1}]
[null,null,6,150,0.5,0.46,0.43,0.39,0.35]
[null,null,7,160,0.57999999999999996,0.54,0.51,0.47,0.43,null,"result =",{"$f":"INDEX(L61:R61,1,M65)","v":1},"PLUS (",{"$f":"M64","v":0.89900000000000002},"MINUS",{"$f":"INDEX(L60:R60,1,M65)","v":0.89900000000000002},") MULT BY (",{"$f":"INDEX(L61:R61,1,M65+1)","v":1.1200000000000001},") MINUS (",{"$f":"INDEX(L61:R61,1,M65)","v":1},")) DIVIDE BY",{"$f":"INDEX(L60:R60,1,M65+1)","v":5},"MINUS",{"$f":"INDEX(L60:R60,1,M65)","v":0.89900000000000002}]
[null,null,8,170,0.67,0.63,0.57999999999999996,0.54,0.51,null,"RESULT",{"$f":"INDEX(L61:R61,1,M65)+((N67-P67)*(R67-T67)/(V67-X67))","v":1}]
[null,null,9,180,0.76,0.71,0.67,0.63,0.57999999999999996]
[null,null,10,190,0.85,0.81,0.76,0.71,0.67]
[null,null,11,200,0.95,0.9,0.85,0.81,0.76]
[null,null,12,210,1.05,1,0.95,0.9,0.85]
[null,null,13,215,1.1000000000000001,1.05,1,0.95,0.9]
[null,null,14,220,1.1499999999999999,1.1000000000000001,1.05,1,0.95]
[null,null,15,230,1.26,1.2,1.1499999999999999,1.1000000000000001,1.05]
[null,null,16,240,1.37,1.32,1.26,1.21,1.1499999999999999]
[null,null,17,250,1.47,1.43,1.37,1.32,1.27]
[]
[null,null,"AWT interpolate value",{"$f":"'Rate Convector'!E24","v":215},null,null,null,null,"EAT Interpolate Value",{"$f":"'Rate Convector'!E22","v":65}]
[null,"Find EAT Index",{"$f":"IF(MATCH(J79,E60:I60,1)=5,4,MATCH(J79,E60:I60,1))","v":3}]
[null,"FIND AWT INDEX",{"$f":"IF(MATCH(D79,D61:D77,1)=17,16,MATCH(D79,D61:D77,1))","v":13}]
[]
[null,"Low EAT Value",{"$f":"INDEX(E61:I77,C81,C80)","v":1},"plus (",{"$f":"D79","v":215},"MINUS",{"$f":"INDEX(D61:D77,C81,1)","v":215},") MULT BY (",{"$f":"INDEX(E61:I77,C81+1,C80)","v":1.05},") MINUS (",{"$f":"INDEX(E61:I77,C81,C80)","v":1},")) DIVIDE BY",{"$f":"INDEX(D61:D77,C81+1,1)","v":220},"MINUS",{"$f":"INDEX(D61:D77,C81,1)","v":215}]
[null,"RESULT",{"$f":"C83+((E83-G83)*(I83-K83)/(M83-O83))","v":1}]
[]
[null,"High EAT Value = ",{"$f":"INDEX(E61:I77,C81,C80+1)","v":0.95},"plus (",{"$f":"D79","v":215},"MINUS",{"$f":"INDEX(D61:D77,C81,1)","v":215},") MULT BY (",{"$f":"INDEX(E61:I77,C81+1,C80+1)","v":1},") MINUS (",{"$f":"INDEX(E61:I77,C81,C80+1)","v":0.95},")) DIVIDE BY",{"$f":"INDEX(D61:D77,C81+1,1)","v":220},"MINUS",{"$f":"INDEX(D61:D77,C81,1)","v":215}]
[null,"RESULT",{"$f":"C86+((E86-G86)*(I86-K86)/(M86-O86))","v":0.95}]
[]
[null,null,{"$f":"C84","v":1},"plus (",{"$f":"J79","v":65},"MINUS",{"$f":"INDEX(E60:I60,1,C80)","v":65},") MULT BY (",{"$f":"C87","v":0.95},") MINUS (",{"$f":"C84","v":1},")) DIVIDE BY",{"$f":"INDEX(E60:I60,1,C80+1)","v":70},"MINUS",{"$f":"INDEX(E60:I60,1,C80)","v":65}]
[null,"result",{"$f":"C89+(E89-G89)*(I89-K89)/(M89-O89)","v":1}]
[]
[]
[]
[]
[]
[]
[null,null,"From Chapter 31 ASHRAE Fundementals Handbook 2009",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From Chapter 31 ASHRAE Fundementals Handbook 2009"]
[null,null,"Table 11 Specific Heat of Aqueous Solutions of Propylene Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11 Specific Heat of Aqueous Solutions of Ethylene Glycol"]
[null,null,null,"Concentrations in Volume Percent Propylene Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concentrations in Volume Percent Propylene Glycol"]
[null,null,null,"Temperature             In °F",null,0,10,20,30,40,50,null,null,null,null,null,null,null,"Temperature             In °F",null,0,10,20,30,40,50]
[null,null,null,null,null,1,2,3,4,5,6,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[null,null,null,100,1,1,0.98099999999999998,0.95899999999999996,0.93100000000000005,0.89900000000000002,0.86099999999999999,null,null,null,null,null,null,null,100,1,1,0.95699999999999996,0.92200000000000004,0.88300000000000001,0.84299999999999997,0.8]
[null,null,null,110,2,1,0.98299999999999998,0.96199999999999997,0.93500000000000005,0.90300000000000002,0.86599999999999999,null,null,null,null,null,null,null,110,2,1,0.95899999999999996,0.92500000000000004,0.88700000000000001,0.84799999999999998,0.80600000000000005]
[null,null,null,120,3,1,0.98499999999999999,0.96499999999999997,0.93899999999999995,0.90800000000000003,0.871,null,null,null,null,null,null,null,120,3,1,0.96099999999999997,0.92800000000000005,0.89100000000000001,0.85199999999999998,0.81100000000000005]
[null,null,null,130,4,1,0.98699999999999999,0.96699999999999997,0.94199999999999995,0.91200000000000003,0.876,null,null,null,null,null,null,null,130,4,1,0.96399999999999997,0.93100000000000005,0.89500000000000002,0.85699999999999998,0.81599999999999995]
[null,null,null,140,5,1,0.98899999999999999,0.97,0.94599999999999995,0.91600000000000004,0.88100000000000001,null,null,null,null,null,null,null,140,5,1,0.96599999999999997,0.93400000000000005,0.89800000000000002,0.86099999999999999,0.82099999999999995]
[null,null,null,150,6,1,0.99099999999999999,0.97299999999999998,0.95,0.92100000000000004,0.88600000000000001,null,null,null,null,null,null,null,150,6,1,0.96799999999999997,0.93700000000000006,0.90200000000000002,0.86499999999999999,0.82599999999999996]
[null,null,null,160,7,1,0.99299999999999999,0.97599999999999998,0.95299999999999996,0.92500000000000004,0.89100000000000001,null,null,null,null,null,null,null,160,7,1,0.97099999999999997,0.94,0.90600000000000003,0.87,0.83099999999999996]
[null,null,null,170,8,1,0.996,0.97899999999999998,0.95699999999999996,0.92900000000000005,0.89600000000000002,null,null,null,null,null,null,null,170,8,1,0.97299999999999998,0.94299999999999995,0.91,0.874,0.83599999999999997]
[null,null,null,180,9,1,0.998,0.98199999999999998,0.96099999999999997,0.93400000000000005,0.90200000000000002,null,null,null,null,null,null,null,180,9,1,0.97499999999999998,0.94599999999999995,0.91300000000000003,0.879,0.84199999999999997]
[null,null,null,190,10,1,1,0.98499999999999999,0.96399999999999997,0.93799999999999994,0.90700000000000003,null,null,null,null,null,null,null,190,10,1,0.97799999999999998,0.94899999999999995,0.91700000000000004,0.88300000000000001,0.84699999999999998]
[null,null,null,200,11,1,1.002,0.98799999999999999,0.96799999999999997,0.94299999999999995,0.91200000000000003,null,null,null,null,null,null,null,200,11,1,0.98,0.95199999999999996,0.92100000000000004,0.88800000000000001,0.85199999999999998]
[null,null,null,210,12,1,1.004,0.99099999999999999,0.97099999999999997,0.94699999999999995,0.91700000000000004,null,null,null,null,null,null,null,210,12,1,0.98199999999999998,0.95499999999999996,0.92500000000000004,0.89200000000000002,0.85699999999999998]
[null,null,null,220,13,1,1.006,0.99399999999999999,0.97499999999999998,0.95099999999999996,0.92200000000000004,null,null,null,null,null,null,null,220,13,1,0.98499999999999999,0.95799999999999996,0.92900000000000005,0.89700000000000002,0.86199999999999999]
[null,null,null,230,14,1,1.008,0.996,0.97899999999999998,0.95599999999999996,0.92700000000000005,null,null,null,null,null,null,null,230,14,1,0.98699999999999999,0.96099999999999997,0.93200000000000005,0.90100000000000002,0.86699999999999999]
[null,null,null,240,15,1,1.0109999999999999,0.999,0.98199999999999998,0.96,0.93200000000000005,null,null,null,null,null,null,null,240,15,1,0.98899999999999999,0.96399999999999997,0.93600000000000005,0.90500000000000003,0.872]
[null,null,null,250,16,1,1.0129999999999999,1.002,0.98599999999999999,0.96499999999999997,0.93700000000000006,null,null,null,null,null,null,null,250,16,1,0.99199999999999999,0.96699999999999997,0.94,0.91,0.877]
[]
[null,null,"AWT interpolate value",{"$f":"D79","v":215},null,null,null,null,"glycol percentage Value",{"$f":"'Rate Convector'!E26","v":0},null,null,null,null,null,null,null,"AWT interpolate value",{"$f":"D79","v":215},null,null,null,null,"glycol percentage Value",{"$f":"'Rate Convector'!E26","v":0}]
[null,"Find glycol Index",{"$f":"IF(MATCH(J119,F100:K100,1)=6,5,MATCH(J119,F100:K100,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"Find glycol Index",{"$f":"IF(MATCH(Y119,U100:Z100,1)=6,5,MATCH(Y119,U100:Z100,1))","v":1}]
[null,"FIND AWT INDEX",{"$f":"IF(MATCH(D119,D102:D117,1)=16,15,MATCH(D119,D102:D117,1))","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,"FIND AWT INDEX",{"$f":"IF(MATCH(S119,S102:S117,1)=16,15,MATCH(S119,S102:S117,1))","v":12}]
[]
[null,"Low glycol Value",{"$f":"INDEX(F102:K117,C121,C120)","v":1},"plus (",{"$f":"D119","v":215},"MINUS",{"$f":"INDEX(D102:D117,C121,1)","v":210},") MULT BY (",{"$f":"INDEX(F102:K117,C121+1,C120)","v":1},") MINUS (",{"$f":"INDEX(F102:K117,C121,C120)","v":1},")) DIVIDE BY",{"$f":"INDEX(D102:D117,C121+1,1)","v":220},"MINUS",{"$f":"INDEX(D102:D117,C121,1)","v":210},null,"Low glycol Value",{"$f":"INDEX(U102:Z117,R121,R120)","v":1},"plus (",{"$f":"S119","v":215},"MINUS",{"$f":"INDEX(S102:S117,R121,1)","v":210},") MULT BY (",{"$f":"INDEX(U102:Z117,R121+1,R120)","v":1},") MINUS (",{"$f":"INDEX(U102:Z117,R121,R120)","v":1},")) DIVIDE BY",{"$f":"INDEX(S102:S117,R121+1,1)","v":220},"MINUS",{"$f":"INDEX(S102:S117,R121,1)","v":210}]
[null,"RESULT",{"$f":"C123+((E123-G123)*(I123-K123)/(M123-O123))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULT",{"$f":"R123+((T123-V123)*(X123-Z123)/(AB123-AD123))","v":1}]
[]
[null,"High glycol Value = ",{"$f":"INDEX(F102:K117,C121,C120+1)","v":1.004},"plus (",{"$f":"D119","v":215},"MINUS",{"$f":"INDEX(D102:D117,C121,1)","v":210},") MULT BY (",{"$f":"INDEX(F102:K117,C121+1,C120+1)","v":1.006},") MINUS (",{"$f":"INDEX(F102:K117,C121,C120+1)","v":1.004},")) DIVIDE BY",{"$f":"INDEX(D102:D117,C121+1,1)","v":220},"MINUS",{"$f":"INDEX(D102:D117,C121,1)","v":210},null,"High glycol Value = ",{"$f":"INDEX(U102:Z117,R121,R120+1)","v":0.98199999999999998},"plus (",{"$f":"S119","v":215},"MINUS",{"$f":"INDEX(S102:S117,R121,1)","v":210},") MULT BY (",{"$f":"INDEX(U102:Z117,R121+1,R120+1)","v":0.98499999999999999},") MINUS (",{"$f":"INDEX(U102:Z117,R121,R120+1)","v":0.98199999999999998},")) DIVIDE BY",{"$f":"INDEX(S102:S117,R121+1,1)","v":220},"MINUS",{"$f":"INDEX(S102:S117,R121,1)","v":210}]
[null,"RESULT",{"$f":"C126+((E126-G126)*(I126-K126)/(M126-O126))","v":1.0049999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULT",{"$f":"R126+((T126-V126)*(X126-Z126)/(AB126-AD126))","v":0.98350000000000004}]
[]
[null,null,{"$f":"C124","v":1},"plus (",{"$f":"J119","v":0},"MINUS",{"$f":"INDEX(F100:K100,1,C120)","v":0},") MULT BY (",{"$f":"C127","v":1.0049999999999999},") MINUS (",{"$f":"C124","v":1},")) DIVIDE BY",{"$f":"INDEX(F100:K100,1,C120+1)","v":10},"MINUS",{"$f":"INDEX(F100:K100,1,C120)","v":0},null,null,{"$f":"R124","v":1},"plus (",{"$f":"Y119","v":0},"MINUS",{"$f":"INDEX(U100:Z100,1,R120)","v":0},") MULT BY (",{"$f":"R127","v":0.98350000000000004},") MINUS (",{"$f":"R124","v":1},")) DIVIDE BY",{"$f":"INDEX(U100:Z100,1,R120+1)","v":10},"MINUS",{"$f":"INDEX(U100:Z100,1,R120)","v":0}]
[null,"glycol cor. Factor",{"$f":"C129+(E129-G129)*(I129-K129)/(M129-O129)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"glycol cor. Factor",{"$f":"R129+(T129-V129)*(X129-Z129)/(AB129-AD129)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Glycol Factor ",null,{"$f":"IF('Hidden Controls'!L20=1,1,IF('Hidden Controls'!L20=2,'Hidden Data'!C130,'Hidden Data'!R130))","v":1}]
[]
[null,null,null,null,"4\" pressure loss",null,null,null,"6\" pressure loss",null,null,null,"8\" pressure loss"]
[null,null,"flow",null,1,null,"flow",null,1,null,"flow",null,1]
[null,null,0,1,0,null,0,1,0,null,0,1,0]
[null,null,0.25,2,4.3999999999999997E-2,null,0.5,2,7.0000000000000007E-2,null,0.5,2,4.5999999999999999E-2]
[null,null,0.5,3,0.16,null,1,3,0.27,null,1,3,0.16700000000000001]
[null,null,1,4,0.59699999999999998,null,2,4,1.0469999999999999,null,2,4,0.61599999999999999]
[null,null,2,5,2.2200000000000002,null,3,5,2.2599999999999998,null,3,5,1.367]
[null,null,null,null,null,null,4,6,3.7930000000000001,null,4,6,2.38]
[null,null,null,null,null,null,null,null,null,null,5,7,3.673]
[]
[null,null,null,null,null,"flow interpolate value",{"$f":"'Rate Convector'!E29","v":0.223}]
[]
[null,"4\" depth interpolation"]
[null,"Find flow Index",{"$f":"IF(MATCH(G143,C135:C139,1)=5,4,MATCH(G143,C135:C139,1))","v":1}]
[null,"4\" Depth Value",{"$f":"INDEX(E135:E139,C146,1)","v":0},"plus (",{"$f":"G143","v":0.223},"MINUS",{"$f":"INDEX(C135:C139,C146,1)","v":0},") MULT BY (",{"$f":"INDEX(E135:E139,C146+1,1)","v":4.3999999999999997E-2},") MINUS (",{"$f":"INDEX(E135:E139,C146,1)","v":0},")) DIVIDE BY",{"$f":"INDEX(C135:C139,C146+1,1)","v":0.25},"MINUS",{"$f":"INDEX(C135:C139,C146,1)","v":0}]
[null,"RESULT",{"$f":"C147+((E147-G147)*(I147-K147)/(M147-O147))","v":3.9247999999999998E-2}]
[null,"check for high flow ",{"$f":"IF(G143>C139,1,0)","v":0},null,"valid result",{"$f":"IF(C149=1,\"*\",C148)","v":3.9247999999999998E-2}]
[]
[null,"6\" depth interpolation"]
[null,"Find flow Index",{"$f":"IF(MATCH(G143,G135:G140,1)=6,5,MATCH(G143,G135:G140,1))","v":1}]
[null,"4\" Depth Value",{"$f":"INDEX(I135:I140,C152,1)","v":0},"plus (",{"$f":"G143","v":0.223},"MINUS",{"$f":"INDEX(G135:G140,C152,1)","v":0},") MULT BY (",{"$f":"INDEX(I135:I140,C152+1,1)","v":7.0000000000000007E-2},") MINUS (",{"$f":"INDEX(I135:I140,C152,1)","v":0},")) DIVIDE BY",{"$f":"INDEX(G135:G140,C152+1,1)","v":0.5},"MINUS",{"$f":"INDEX(G135:G140,C152,1)","v":0}]
[null,"RESULT",{"$f":"C153+((E153-G153)*(I153-K153)/(M153-O153))","v":3.1220000000000005E-2}]
[null,"check for high flow ",{"$f":"IF(G143>G140,1,0)","v":0},null,"valid result",{"$f":"IF(C155=1,\"*\",C154)","v":3.1220000000000005E-2}]
[]
[null,"8\" depth interpolation"]
[null,"Find flow Index",{"$f":"IF(MATCH(G143,K135:K141,1)=7,6,MATCH(G143,K135:K141,1))","v":1}]
[null,"4\" Depth Value",{"$f":"INDEX(M135:M141,C158,1)","v":0},"plus (",{"$f":"G143","v":0.223},"MINUS",{"$f":"INDEX(K135:K141,C158,1)","v":0},") MULT BY (",{"$f":"INDEX(M135:M141,C158+1,1)","v":4.5999999999999999E-2},") MINUS (",{"$f":"INDEX(M135:M141,C158,1)","v":0},")) DIVIDE BY",{"$f":"INDEX(K135:K141,C158+1,1)","v":0.5},"MINUS",{"$f":"INDEX(K135:K141,C158,1)","v":0}]
[null,"RESULT",{"$f":"C159+((E159-G159)*(I159-K159)/(M159-O159))","v":2.0516E-2}]
[null,"check for high flow ",{"$f":"IF(G143>K141,1,0)","v":0},null,"valid result",{"$f":"IF(C161=1,\"*\",C160)","v":2.0516E-2}]
[]
[null,"Unit Selected result",{"$f":"IF('Hidden Controls'!F4=1,'Hidden Data'!F149,IF('Hidden Controls'!F4=2,'Hidden Data'!F155,'Hidden Data'!F161))","v":3.9247999999999998E-2}]
["Check unit high flow",null,{"$f":"IF(AND('Hidden Controls'!F4=1,C149=1),1,IF(AND('Hidden Controls'!F4=2, C155=1),1,IF(AND('Hidden Controls'!F4=3,C161=1),1,0)))","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Density of Water",null,null,null,"Viscosity of Water"]
[null,null,null,null,null,null,null,null,"Temp (F)","Density (lb/ft^3)","Density (slug/ft^3)",null,"Temp (F)","Dynamic Viscosity (lb-sec/ft^2)",null,"target",{"$f":"'Rate Convector'!E24","v":215}]
[null,null,null,null,null,null,null,null,50,62.408000000000001,{"$f":"J172*0.031080949","v":1.9396998651920001},null,50,2.73E-5,null,"index low",{"$f":"IF(MATCH(Q171,I172:I189,1)=18, 17,MATCH(Q171,I172:I189,1))","v":17}]
[null,null,null,null,null,null,null,null,60,62.366,{"$f":"J173*0.031080949","v":1.9383944653339999},null,60,2.3439999999999999E-5,null,"index high",{"$f":"Q172+1","v":18}]
[null,"intermediate calculations",null,null,null,null,null,null,70,62.3,1.9363431226999999,null,70,2.0339999999999998E-5]
[null,null,"fluid viscosity (u)",{"$f":"Q185 + N234 + AB234","v":5.7900000000000005E-6},"lb-sec/ft^2",null,null,null,80,62.216999999999999,1.9337634039330001,null,80,1.791E-5,null,"temp low",{"$f":"INDEX(I172:I189,Q172,1)","v":210}]
[null,null,"fluid density (p)",{"$f":"Q184 +M213+ AA213","v":1.8566204885149999},"slug/ft^3",null,null,null,90,62.118000000000002,1.9306863899820002,null,90,1.5E-5,null,"temp high",{"$f":"INDEX(I172:I189,Q173,1)","v":220}]
[null,"tube inside diameter",null,0.34100000000000003,"inches","(measured data)",null,null,100,61.997999999999998,1.9269566761019998,null,100,1.4229999999999999E-5]
[null,null,"tube inside diameter",{"$f":"D177/12","v":2.841666666666667E-2},"ft",null,null,null,110,61.859000000000002,1.9226364241910001,null,110,1.294E-5,null,"density low",{"$f":"INDEX(K172:K189,Q172,1)","v":1.8605056071399999}]
[null,null,"Tube Roughness ( e )",5.0000000000000004E-6,"ft",null,null,null,120,61.719000000000001,1.9182850913310001,null,120,1.164E-5,null,"density high",{"$f":"INDEX(K172:K189,Q173,1)","v":1.85273536989}]
[null,null,"Number of Tubes",{"$f":"'Hidden Controls'!F4+1","v":2},null,null,null,null,130,61.552999999999997,1.9131256537969998,null,130,1.0689999999999999E-5]
[null,null,"GPM per tube",{"$f":"'Rate Convector'!E29/D180","v":0.1115},null,null,null,null,140,61.386000000000003,1.9079351353140002,null,140,9.7399999999999999E-6,null,"viscosity low",{"$f":"INDEX(N172:N189,Q172,1)","v":5.9599999999999997E-6}]
[null,null,"Velocity =",{"$f":"D181*0.1336809/(60*PI()*(0.5*D178)^2)","v":0.39170293933874445},"fps",null,null,null,150,61.195999999999998,1.902029755004,null,150,9.0299999999999999E-6,null,"viscosity high",{"$f":"INDEX(N172:N189,Q173,1)","v":5.6200000000000004E-6}]
[null,null,"Reynolds No. (Re)",{"$f":"D178*D182*D176/D175","v":3569.2300314113509},null,null,null,null,160,61.006,1.896124374694,null,160,8.32E-6]
[null,null,"Type of Flow",{"$f":"IF(D183<2300,\"Laminar Flow\",IF(D183>4000,\"Completely Turbulent Flow\",\"Transition Flow Region\"))","v":"Transition Flow Region"},null,null,null,null,170,60.798999999999999,1.889690618251,null,170,7.7700000000000001E-6,null,"density",{"$f":"IF('Hidden Controls'!L20=1,((Q171-Q175)/(Q176-Q175))*(Q179-Q178) +Q178,0)","v":1.8566204885149999}]
[null,null,"Glycol type",{"$f":"INDEX('Hidden Controls'!J20:J22,'Hidden Controls'!L20)","v":"Water"},null,null,null,null,180,60.585999999999999,1.883070376114,null,180,7.2099999999999996E-6,null,"viscosity",{"$f":"IF('Hidden Controls'!L20=1,((Q171-Q175)/(Q176-Q175))*(Q182-Q181) +Q181,0)","v":5.7900000000000005E-6}]
[null,null,null,null,null,null,null,null,190,60.360999999999997,1.8760771625889998,null,190,6.7800000000000003E-6]
[null,null,null,null,null,null,null,null,200,60.134999999999998,1.869052868115,null,200,6.3400000000000003E-6]
[null,null,null,null,null,null,null,null,210,59.86,1.8605056071399999,null,210,5.9599999999999997E-6]
[null,null,null,null,null,null,null,null,220,59.61,1.85273536989,null,220,5.6200000000000004E-6]
[]
[null,null,null,null,"Density of Propylene Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,"Density of Ethylene Glycol"]
[null,null,null,null,"percent Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,"percent Glycol"]
[null,null,null,null,0,10,20,30,40,50,60,null,null,null,null,null,null,null,0,10,20,30,40,50,60]
[null,null,null,"Temp (F)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)",null,null,null,null,null,null,"Temp (F)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)","Density (slug/ft^3)"]
[null,null,null,50,1.9396998651920001,1.9643159768,1.9866942600800002,2.0056536389700002,2.0221265419400001,2.0358021595000002,2.04730211063,null,null,null,null,null,null,50,1.9396998651920001,1.9742618804800001,2.0065860674400002,2.0373562069499997,2.0659506800299998,2.0929911056599999,2.1187882933300002]
[null,null,null,60,1.9383944653339999,1.9612078819000001,1.9826537367099999,2.0013023061099999,2.0171535901000004,2.0305183981699999,2.0413967303200002,null,null,null,null,null,null,60,1.9383944653339999,1.9711537855800001,2.0031671630500001,2.0336264930700003,2.0619101566600002,2.0886397728000001,2.1141261509799998]
[null,null,null,70,1.9363431226999999,1.95747816802,1.9786132133399998,1.9966401637599998,2.0118698287700001,2.0246130178600001,2.0348697310300001,null,null,null,null,null,null,70,1.9363431226999999,1.9677348811900002,1.99943744917,2.0295859696999998,2.0575588238,2.0839776304499997,2.1091531991400001]
[null,null,null,80,1.9337634039330001,1.9537484541400001,1.9742618804800001,1.9916672119199998,2.0062752579500001,2.0187076375499999,2.02834273174,null,"target",{"$f":"Q171","v":215},{"$f":"'Rate Convector'!E26","v":0},null,null,80,1.9337634039330001,1.9640051673099999,1.9957077352899999,2.0255454463300002,2.05289668145,2.0793154881000002,2.1038694378099998,null,"target",{"$f":"Q171","v":215},{"$f":"'Rate Convector'!E26","v":0}]
[null,null,null,90,1.9306863899820002,1.9497079307699998,1.9695997381299999,1.98638345059,2.0003698776399998,2.0121806382599998,2.0215049229600002,null,"index low",{"$f":"IF(MATCH(N198,D195:D212,1)=18, 17,MATCH(N198,D195:D212,1))","v":17},{"$f":"IF(MATCH(O198,E193:K193,1)=7, 6,MATCH(O198,E193:K193,1))","v":1},null,null,90,1.9306863899820002,1.96027545343,1.9913564024299999,2.0208833039799998,2.0482345391000001,2.0740317267699999,2.0982748669900002,null,"index low",{"$f":"IF(MATCH(AB198,R195:R212,1)=18, 17,MATCH(AB198,R195:R212,1))","v":17},{"$f":"IF(MATCH(AC198,S193:Y193,1)=7, 6,MATCH(AC198,S193:Y193,1))","v":1}]
[null,null,null,100,1.9269566761019998,1.94535659791,1.9643159768,1.98078887977,1.9941536878399999,2.0056536389700002,2.0143563046900002,null,"index high",{"$f":"N199+1","v":18},{"$f":"O199+1","v":2},null,null,100,1.9269566761019998,1.95592412057,1.9870050695699999,2.0159103521400001,2.0429507777700002,2.0684371559499999,2.09236948668,null,"index high",{"$f":"AB199+1","v":18},{"$f":"AC199+1","v":2}]
[null,null,null,110,1.9226364241910001,1.9406944555599999,1.9590322154699999,1.97488349946,1.98762668855,1.9985050206999999,2.00689687693,null,null,"temp","percent",null,null,110,1.9226364241910001,1.95157278771,1.9820321177300002,2.0109374003,2.0376670164399999,2.0628425851300003,2.0864641063699998,null,null,"temp","percent"]
[null,null,null,120,1.9182850913310001,1.93572150372,1.9534376446500001,1.9683565001699999,1.9810996892600001,1.9910455929400002,1.9991266396799998,null,"low",{"$f":"INDEX(D195:D212,N199,1)","v":210},{"$f":"INDEX(E193:K193,1,O199)","v":0},null,null,120,1.9182850913310001,1.9465998358700001,1.9770591658900001,2.00534282948,2.0317616361300002,2.0566263953299999,2.0799371070800001,null,"low",{"$f":"INDEX(R195:R212,AB199,1)","v":210},{"$f":"INDEX(S193:Y193,1,AC199)","v":0}]
[null,null,null,130,1.9131256537969998,1.9304377423899999,1.9475322643399999,1.96182950088,1.9739510709899999,1.98358616518,1.9910455929400002,null,"high",{"$f":"INDEX(D195:D212,N200,1)","v":220},{"$f":"INDEX(E193:K193,1,O200)","v":10},null,null,130,1.9131256537969998,1.9416268840299999,1.97146459507,1.9997482586600002,2.0258562558200004,2.05041020553,2.07341010779,null,"high",{"$f":"INDEX(R195:R212,AB200,1)","v":220},{"$f":"INDEX(S193:Y193,1,AC200)","v":10}]
[null,null,null,140,1.9079351353140002,1.9248431715700001,1.94131607454,1.9549916920999999,1.9664916432300001,1.97581592793,1.9826537367099999,null,null,null,null,null,null,140,1.9079351353140002,1.9363431226999999,1.96587002425,1.9938428783500002,2.01964006602,2.0435723967500001,2.06626148952]
[null,null,null,150,1.902029755004,1.9189377912600001,1.9347890752500001,1.9478430738300001,1.95872140598,1.9674240717,1.9739510709899999,null,"density low",{"$f":"INDEX(E195:K212,N199,O199)","v":1.8605056071399999},null,null,null,150,1.902029755004,1.9304377423899999,1.95996464394,1.98762668855,2.0128022572400002,2.0367345879699998,2.05911287125,null,"density low",{"$f":"INDEX(S195:Y212,AB199,AC199)","v":1.8605056071399999}]
[null,null,null,160,1.896124374694,1.9127216014599999,1.92795126647,1.9403836460699999,1.9506403592399999,1.9590322154699999,1.9649375957799999,null,"density high",{"$f":"INDEX(E195:K212,N200,O199)","v":1.85273536989},null,null,null,160,1.896124374694,1.9245323620800001,1.9537484541400001,1.98078887977,2.0059644484600003,2.0295859696999998,2.0513426340000001,null,"density high",{"$f":"INDEX(S195:Y212,AB200,AC199)","v":1.85273536989}]
[null,null,null,170,1.889690618251,1.90619460217,1.9208026482,1.93261340882,1.9422485030100001,1.95001874026,1.95561331108,null,"low percent",{"$f":"((N198-N202)/(N203-N202))*(N206-N205) +N205","v":1.8566204885149999},null,null,null,170,1.889690618251,1.91831617228,1.94691064536,1.9739510709899999,1.9988158301900001,2.0218157324499999,2.0435723967500001,null,"low percent",{"$f":"((AB198-AB202)/(AB203-AB202))*(AB206-AB205) +AB205","v":1.8566204885149999}]
[null,null,null,180,1.883070376114,1.89935679339,1.91334322044,1.9245323620800001,1.93385664678,1.94100526505,1.9459782168899999,null,null,null,null,null,null,180,1.883070376114,1.9117891729899998,1.94007283658,1.9668024527200001,1.9913564024299999,2.0140454952,2.03549135001]
[null,null,null,190,1.8760771625889998,1.8925189846100001,1.9055729831900001,1.9161405058500001,1.9248431715700001,1.93137017086,1.9360323132099999,null,"density low",{"$f":"INDEX(E195:K212,N199,O200)","v":1.87760012909},null,null,null,190,1.8760771625889998,1.90495136421,1.9329242183099999,1.9593430249599999,1.98358616518,2.0059644484600003,2.02678868429,null,"density low",{"$f":"INDEX(S195:Y212,AB199,AC200)","v":1.89034331818}]
[null,null,null,200,1.869052868115,1.8850595568499999,1.8974919364499998,1.9074378401299998,1.9155188868700002,1.9217350766699999,1.9260864095299999,null,"density high",{"$f":"INDEX(E195:K212,N200,O200)","v":1.90060003135},null,null,null,200,1.869052868115,1.89780274594,1.9254647905500002,1.95157278771,1.9755051184400001,1.9975725922299998,2.01808601857,null,"density high",{"$f":"INDEX(S195:Y212,AB200,AC200)","v":1.8825730809300001}]
[null,null,null,210,1.8605056071399999,1.87760012909,1.88910008022,1.8984243649199999,1.9058837926800001,1.9114783635000001,1.9155188868700002,null,"high percent",{"$f":"((N198-N202)/(N203-N202))*(N210-N209) +N209","v":1.88910008022},null,null,null,210,1.8605056071399999,1.89034331818,1.91800536279,1.9434917409700001,1.96711326221,1.9888699265100001,2.0090725433599999,null,"high percent",{"$f":"((AB198-AB202)/(AB203-AB202))*(AB210-AB209) +AB209","v":1.886458199555}]
[null,null,null,220,1.85273536989,1.90060003135,1.8803974145,1.88910008022,1.895937889,1.9012216503300001,1.90464055472,null,null,{"$f":"IF(E162=\"None\",((N198-N202)/(N203-N202))*(N206-N205) +N205,\"\")","v":""},null,null,null,220,1.85273536989,1.8825730809300001,1.9099243160500001,1.93541069423,1.95841059649,1.9798564513000001,1.9997482586600002,null,null,{"$f":"IF(S162=\"None\",((AB198-AB202)/(AB203-AB202))*(AB206-AB205) +AB205,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"final density",{"$f":"IF('Hidden Controls'!L20=2,((O198-O202)/(O203-O202))*(N211-N207)+N207,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"final density",{"$f":"IF('Hidden Controls'!L20=3,((AC198-AC202)/(AC203-AC202))*(AB211-AB207) +AB207,0)","v":0}]
[]
[null,null,null,"Viscosity of Propylene Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,"Viscosity of Ethylene Glycol"]
[null,null,null,null,"percent Glycol",null,null,null,null,null,null,null,null,null,null,null,null,null,"percent Glycol"]
[null,null,null,null,0,10,20,30,40,50,60,null,null,null,null,null,null,null,0,10,20,30,40,50,60]
[null,null,null,"Temp (F)","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2",null,null,null,null,null,null,"Temp (F)","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2","lbsec/ft^2"]
[null,null,null,50,2.73E-5,3.9473462699999998E-5,5.8270349699999999E-5,9.4402143599999996E-5,1.507928046E-4,2.224298295E-4,3.5609658150000004E-4,null,"target",{"$f":"Q171","v":215},{"$f":"'Rate Convector'!E26","v":0},null,null,50,2.73E-5,3.2581270800000003E-5,4.5530237400000001E-5,6.16120185E-5,8.43771372E-5,1.14869865E-4,1.6395062549999999E-4,null,"target",{"$f":"Q171","v":215},{"$f":"'Rate Convector'!E26","v":0}]
[null,null,null,60,2.3439999999999999E-5,3.3416688000000002E-5,4.8454197599999996E-5,7.5396402300000002E-5,1.159141365E-4,1.6979854590000001E-4,2.6294756370000001E-4,null,"index low",{"$f":"IF(MATCH(N219,D219:D236,1)=18, 17,MATCH(N219,D219:D236,1))","v":17},{"$f":"IF(MATCH(O219,E217:K217,1)=7, 6,MATCH(O219,E217:K217,1))","v":1},null,null,60,2.3439999999999999E-5,2.8195330500000001E-5,3.8846899800000006E-5,5.2004720700000003E-5,7.0592753399999997E-5,9.5028706499999995E-5,1.322047719E-4,null,"index low",{"$f":"IF(MATCH(AB219,R219:R236,1)=18, 17,MATCH(AB219,R219:R236,1))","v":17},{"$f":"IF(MATCH(AC219,S217:Y217,1)=7, 6,MATCH(AC219,S217:Y217,1))","v":1}]
[null,null,null,70,2.0339999999999998E-5,2.88218934E-5,4.0726588500000003E-5,6.14031642E-5,9.1060474800000002E-5,1.3241362620000001E-4,1.9862043929999999E-4,null,"index high",{"$f":"N220+1","v":18},{"$f":"O220+1","v":2},null,null,70,2.0339999999999998E-5,2.4644807400000001E-5,3.3625542300000002E-5,4.4485965899999996E-5,5.9941184100000003E-5,7.9573488300000009E-5,1.079776731E-4,null,"index high",{"$f":"AB220+1","v":18},{"$f":"AC220+1","v":2}]
[null,null,null,80,1.791E-5,2.5062516E-5,3.46698138E-5,5.0751594900000005E-5,7.3099005000000006E-5,1.052625672E-4,1.532990562E-4,null,null,"temp","percent",null,null,80,1.791E-5,2.1720847200000002E-5,2.9448456299999999E-5,3.84291912E-5,5.1378157799999997E-5,6.7459938900000003E-5,8.9389640400000005E-5,null,null,"temp","percent"]
[null,null,null,90,1.5E-5,2.1929701500000002E-5,2.9866164899999998E-5,4.2606277199999999E-5,5.9732329799999996E-5,8.5212554399999999E-5,1.2050893109999999E-4,null,"low",{"$f":"INDEX(D219:D236,N220,1)","v":210},{"$f":"INDEX(E217:K217,1,O220)","v":0},null,null,90,1.5E-5,1.9423449900000003E-5,2.5897933200000002E-5,3.3416688000000002E-5,4.4485965899999996E-5,5.76437868E-5,7.4769839400000003E-5,null,"low",{"$f":"INDEX(R219:R236,AB220,1)","v":210},{"$f":"INDEX(S217:Y217,1,AC220)","v":0}]
[null,null,null,100,1.4229999999999999E-5,1.9423449900000003E-5,2.6106787500000001E-5,3.6131793899999997E-5,4.9498469100000001E-5,6.9966190499999998E-5,9.6490686600000006E-5,null,"high",{"$f":"INDEX(D219:D236,N221,1)","v":220},{"$f":"INDEX(E217:K217,1,O221)","v":10},null,null,100,1.4229999999999999E-5,1.73349069E-5,2.3182827300000003E-5,2.3809390199999999E-5,3.9055754100000006E-5,4.9916177700000007E-5,6.3282852899999997E-5,null,"high",{"$f":"INDEX(R219:R236,AB221,1)","v":220},{"$f":"INDEX(S217:Y217,1,AC221)","v":10}]
[null,null,null,110,1.294E-5,1.73349069E-5,2.2973973000000003E-5,3.1119290699999999E-5,4.1770860000000001E-5,5.8270349699999999E-5,7.8529216799999997E-5,null,null,null,null,null,null,110,1.294E-5,1.5664072499999999E-5,2.0676575700000001E-5,2.6106787500000001E-5,3.42521052E-5,4.3441694400000005E-5,5.38844094E-5]
[null,null,null,120,1.164E-5,1.5664072499999999E-5,2.0258867100000001E-5,2.7151059000000003E-5,3.5714085299999998E-5,4.9289614800000001E-5,6.4953687299999994E-5,null,"viscosity low",{"$f":"INDEX(E219:K236,N220,O220)","v":5.9599999999999997E-6},null,null,null,120,1.164E-5,1.4202092400000002E-5,1.8796887000000001E-5,2.3182827300000003E-5,3.04927278E-5,3.8011482600000001E-5,4.6574508899999999E-5,null,"viscosity low",{"$f":"INDEX(S219:Y236,AB220,AC220)","v":5.9599999999999997E-6}]
[null,null,null,130,1.0689999999999999E-5,1.4202092400000002E-5,1.8170324100000002E-5,2.3809390199999999E-5,3.1119290699999999E-5,4.21885686E-5,5.4510972299999999E-5,null,"viscosity high",{"$f":"INDEX(E219:K236,N221,O220)","v":5.6200000000000004E-6},null,null,null,130,1.0689999999999999E-5,1.2948966600000001E-5,1.6917198300000001E-5,2.088543E-5,2.7151059000000003E-5,3.3625542300000002E-5,4.0308879899999997E-5,null,"viscosity high",{"$f":"INDEX(S219:Y236,AB221,AC220)","v":5.6200000000000004E-6}]
[null,null,null,140,9.7399999999999999E-6,1.2948966600000001E-5,1.6290635400000002E-5,2.10942843E-5,2.7151059000000003E-5,3.6549502500000003E-5,4.6365654600000006E-5,null,"low percent",{"$f":"((N219-N223)/(N224-N223))*(N227-N226) +N226","v":5.7900000000000005E-6},null,null,null,140,9.7399999999999999E-6,1.1904695099999999E-5,1.54552182E-5,1.8796887000000001E-5,2.4435953099999997E-5,2.9866164899999998E-5,3.5296376699999999E-5,null,"low percent",{"$f":"((AB219-AB223)/(AB224-AB223))*(AB227-AB226) +AB226","v":5.7900000000000005E-6}]
[null,null,null,150,9.0299999999999999E-6,1.1904695099999999E-5,1.4828655299999999E-5,1.8796887000000001E-5,2.4227098799999998E-5,3.1954707899999998E-5,3.9891171299999997E-5,null,null,null,null,null,null,150,9.0299999999999999E-6,1.1069277900000001E-5,1.4202092400000002E-5,1.71260526E-5,2.1929701500000002E-5,2.67333504E-5,3.1119290699999999E-5]
[null,null,null,160,8.32E-6,1.0860423600000001E-5,1.33666752E-5,1.71260526E-5,2.1511992899999999E-5,2.8195330500000001E-5,3.46698138E-5,null,"viscosity low",{"$f":"INDEX(E219:K236,N220,O221)","v":7.5187548000000003E-6},null,null,null,160,8.32E-6,1.0233860700000001E-5,1.31578209E-5,1.5664072499999999E-5,1.9841158499999999E-5,2.4018244499999998E-5,2.7568767600000002E-5,null,"viscosity low",{"$f":"INDEX(S219:Y236,AB220,AC221)","v":7.3099004999999998E-6}]
[null,null,null,170,7.7700000000000001E-6,1.0025006399999999E-5,1.23224037E-5,1.54552182E-5,1.9423449900000003E-5,2.5062516E-5,3.0283873500000001E-5,null,"viscosity high",{"$f":"INDEX(E219:K236,N221,O221)","v":7.101046200000001E-6},null,null,null,170,7.7700000000000001E-6,9.6072978E-6,1.2113549399999999E-5,1.4202092400000002E-5,1.8170324100000002E-5,2.1720847200000002E-5,2.4644807400000001E-5,null,"viscosity high",{"$f":"INDEX(S219:Y236,AB221,AC221)","v":6.8921919000000005E-6}]
[null,null,null,180,7.2099999999999996E-6,9.1895892000000007E-6,1.12781322E-5,1.4202092400000002E-5,1.7752615499999999E-5,2.2556264400000001E-5,2.69422047E-5,null,"high percent",{"$f":"((N219-N223)/(N224-N223))*(N231-N230) +N230","v":7.3099005000000006E-6},null,null,null,180,7.2099999999999996E-6,8.9807348999999994E-6,1.12781322E-5,1.31578209E-5,1.6499489700000001E-5,1.9632304199999999E-5,2.2138555800000002E-5,null,"high percent",{"$f":"((AB219-AB223)/(AB224-AB223))*(AB231-AB230) +AB230","v":7.1010462000000002E-6}]
[null,null,null,190,6.7800000000000003E-6,8.5630263000000001E-6,1.0442715E-5,1.2948966600000001E-5,1.6290635400000002E-5,2.0258867100000001E-5,2.4018244499999998E-5,null,null,{"$f":"IF(C156=\"None\",((N219-N223)/(N224-N223))*(N227-N226) +N226,\"\")","v":""},null,null,null,190,6.7800000000000003E-6,8.3541720000000005E-6,1.0442715E-5,1.2113549399999999E-5,1.52463639E-5,1.7752615499999999E-5,1.9841158499999999E-5,null,null,{"$f":"IF(Q156=\"None\",((AB219-AB223)/(AB224-AB223))*(AB227-AB226) +AB226,\"\")","v":""}]
[null,null,null,200,6.3400000000000003E-6,7.9364633999999995E-6,9.6072978E-6,1.2113549399999999E-5,1.5037509600000001E-5,1.8379178400000001E-5,2.1720847200000002E-5,null,"Prop. viscosity",{"$f":"IF('Hidden Controls'!L20=2,((O219-O223)/(O224-O223))*(N232-N228) +N228,0)","v":0},null,null,null,200,6.3400000000000003E-6,7.7276090999999999E-6,9.8161520999999996E-6,1.12781322E-5,1.3993238100000001E-5,1.6290635400000002E-5,1.7961469799999999E-5,null,"Eth. viscosity",{"$f":"IF('Hidden Controls'!L20=3,((AC219-AC223)/(AC224-AC223))*(AB232-AB228) +AB228,0)","v":0}]
[null,null,null,210,5.9599999999999997E-6,7.5187548000000003E-6,8.9807348999999994E-6,1.12781322E-5,1.3993238100000001E-5,1.6917198300000001E-5,1.9632304199999999E-5,null,null,null,null,null,null,210,5.9599999999999997E-6,7.3099004999999998E-6,8.9807348999999994E-6,1.0442715E-5,1.27401123E-5,1.4828655299999999E-5,1.6290635400000002E-5]
[null,null,null,220,5.6200000000000004E-6,7.101046200000001E-6,8.3541720000000005E-6,1.0442715E-5,1.2948966600000001E-5,1.54552182E-5,1.7961469799999999E-5,null,null,null,null,null,null,220,5.6200000000000004E-6,6.8921919000000005E-6,8.5630263000000001E-6,9.6072978E-6,1.1904695099999999E-5,1.3784383800000001E-5,1.3784383800000001E-5]
[]
[null,"Equations:",null,null,null,null,null,null,null,"Legend:",null,null,"Final density",{"$f":"SUM(N234,M213,Q184)","v":1.8566204885149999},null,null,null,null,null,"Final Viscosity",null,{"$f":"SUM(AB234,Q185,N234)","v":5.7900000000000005E-6}]
[null,"Re = D * V * p / u",null,null,null,null,null,null,null,"Re = Reynolds Number"]
[null,null,null,null,null,null,null,null,null,"D = inside diameter (feet)"]
[null,"V = Re *u / (D * p)",null,null,null,null,null,null,null,"V = velocity (ft/sec)"]
[null,null,null,null,null,null,null,null,null,"p = fluid density  (slugs/ft^3)"]
[null,"Velocity @ laminar flow = 2300 * u / (D * p)",null,null,null,null,"Re = 2300 at laminar flow",null,null,"u = fluid dynamic viscosity ( lb-sec/ft^2)"]
[]
[null,"Velocity @ turbulent flow = 4000 * u / (D * p)",null,null,null,null,"Re = 4000 at turbulent flow"]
[]
[null,"Velocity (ft/sec) = (GPM(gal/min)) / (60 sec/min * Area (ft²)* 7.4805(gal/cu ft))"]
[]
[null,"Minimum Flow Calculation"]
[null,"1) calculate velocity @ Re = 2300",null,null,null," low velocity =",{"$f":"2300*D175/(D178*D176)","v":0.25241207558787415}]
[null,"2) calculate tube gpm @ Re=2300",null,null,null,"Tube GPM =",{"$f":"G250*60*PI()*(D178/2)^2*7.4805","v":7.1850228390406279E-2}]
[null,"3) calculate gpm for the element @ Re=2300",null,null,null,"GPM =",{"$f":"D180*G251","v":0.14370045678081256}]
[]
[]
[]
[]
[]
[]
[null,"Water temperature drop Factor calculation"]
[null,"using factors from Trane Catalog"]
[]
[null,"drop","factor",null,"target",{"$f":"'Rate Convector'!E25","v":20}]
[null,5,1.139,null,"index low",{"$f":"IF(F262<B263,1,IF(MATCH(F262,B263:B266)=4,3,MATCH(F262,B263:B266)))","v":3}]
[null,10,1.087,null,"index high",{"$f":"F263+1","v":4}]
[null,20,1,null,"low",{"$f":"INDEX(B263:B266,F263)","v":20},{"$f":"INDEX(C263:C266,F263)","v":1}]
[null,30,0.92800000000000005,null,"high",{"$f":"INDEX(B263:B266,F264)","v":30},{"$f":"INDEX(C263:C266,F264)","v":0.92800000000000005}]
[null,null,null,null,"factor",{"$f":"((F262-F265)/(F266-F265))*(G266-G265) +G265","v":1}]
[]
[]
[]
[null,"This table is air density ratio based altitude correction factors"]
[null,"Per calculations by M. Girard March 2014"]
[]
[null,"Altitude","cf",null,"target",{"$f":"'Rate Convector'!E15","v":0}]
[1,0,1,null,"index low",{"$f":"IF(MATCH(F274,B275:B285)=11,10,MATCH(F274,B275:B285))","v":1}]
[2,1000,0.97093743702325264,null,"index high",{"$f":"F275+1","v":2}]
[3,2000,0.94252232860677199,null,"low",{"$f":"INDEX(B275:B285,F275)","v":0},{"$f":"INDEX(C275:C285,F275)","v":1}]
[4,3000,0.91475038697201372,null,"high",{"$f":"INDEX(B275:B285,F276)","v":1000},{"$f":"INDEX(C275:C285,F276)","v":0.97093743702325264}]
[5,4000,0.88761303656188761,null,"factor",{"$f":"((F274-F277)/(F278-F277))*(G278-G277) +G277","v":1}]
[6,5000,0.86108883848367002]
[7,6000,0.83517779273736059]
[8,7000,0.80987132376587012]
[9,8000,0.78515228045501906]
[10,9000,0.76101637502626251]
[11,10000,0.7374507441439665]

{"sheet":"Hidden Controls","index":1,"n_rows":95,"n_cols":19,"rows_kept":95,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Convector type",null,null,"Convector Depth",null,null,"Convector Length",null,null,"convector height",null,null,null,"convector height",null,"FS-A, FSG-A, FWG-A, RF-A, RFG-A, SF-A, SFG-A"]
[1,"FS-A",1,null,4,1,null,20,1,null,{"$f":"IF(OR(C4=4, C4=5),18,IF(OR(C4=10, C4=11),16,IF(OR(C4=12, C4=13),14,18)))","v":18},1,null,null,18,null,"1,2,3,6,7,8,9"]
[2,"FSG-A",null,null,6,null,null,24,null,null,{"$f":"IF(OR(C4=4, C4=5),20,IF(OR(C4=10, C4=11),18,IF(OR(C4=12, C4=13),18,20)))","v":20},null,null,null,20]
[3,"FWG-A",null,null,8,null,null,28,null,null,{"$f":"IF(OR(C4=4, C4=5),24,IF(OR(C4=10, C4=11),22,IF(OR(C4=12, C4=13),20,24)))","v":24},null,null,null,24]
[4,"PW-A",null,null,null,null,null,32,null,null,{"$f":"IF(OR(C4=4, C4=5),26,IF(OR(C4=10, C4=11),24,IF(OR(C4=12, C4=13),26,26)))","v":26},null,null,null,26]
[5,"PWG-A",null,null,null,null,null,36,null,null,{"$f":"IF(OR(C4=4, C4=5),28,IF(OR(C4=10, C4=11),30,IF(OR(C4=12, C4=13),32,32)))","v":32},null,null,null,32]
[6,"RF-A",null,null,"min flow limit",null,null,40]
[7,"RFG-A",null,null,{"$f":"IF(F4=1,0.15,IF(F4=2,0.225,0.3))","v":0.15},null,null,44]
[8,"SF-A",null,null,null,null,null,48,null,null,null,null,null,null,"convector height",null,"PW-A, PWG-A"]
[9,"SFG-A",null,null,null,null,null,52,null,null,null,null,null,null,18,null,"4,5"]
[10,"SR-A",null,null,null,null,null,56,null,null,null,null,null,null,20]
[11,"SRG-A",null,null,null,null,null,60,null,null,null,null,null,null,24]
[12,"SW-A",null,null,null,null,null,64,null,null,null,null,null,null,26]
[13,"W-A",null,null,null,null,null,null,null,null,null,null,null,null,28]
[]
[]
[null,"lh end pocket",null,false,"true= pocket, false = no pocket",null,null,null,null,"Fluid Selection",null,null,null,null,"convector height",null,"SR-A, SRG-A"]
[null,"rh end pocket",null,false,null,null,null,null,null,"Water",null,1,null,null,16,null,"10,11"]
[null,null,null,null,null,null,null,null,null,"Proplyene Glycol Mix",null,null,null,null,18]
[null,"lh access door",null,null,"rh access door",null,null,null,null,"Ethylene Glycol Mix",null,null,null,null,22]
[null,"#3",false,null,"#4",false,null,null,null,null,null,null,null,null,24]
[null,"#1",false,null,"#2",false,null,null,null,null,null,null,null,null,30]
[null,"#5",false,null,"#6",false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"convector height",null,"SW-A, W-A"]
[null,null,null,null,null,"height",null,null,null,null,null,null,null,null,14,null,"12,13"]
[null,"Grille Derate",null,null," 16, 18",20,"22, 24",26,"28, 30, 32",null,null,null,null,null,18]
[null,null,null,null,1,2,3,4,5,null,null,null,null,null,20]
[null,null,4,1,0.97,0.97,0.98,0.98,0.99,null,null,null,null,null,26]
[null,"depth",6,2,0.94,0.94,0.95,0.95,0.98,null,null,null,null,null,32]
[null,null,8,3,0.91,0.91,0.93,0.93,0.97]
[]
[null,null,"temp grille derate factor = ",{"$f":"HLOOKUP(L4,E30:I33,1+F4,FALSE)","v":0.97},null,null,"final grille factor =",{"$f":"IF(OR(C4=2, C4=3, C4=5, C4=7, C4=9, C4=11),D35,1)","v":1}]
[]
[null,"Access Door Derate"]
[null,"FS-A, FSG-A, SF-A, SFG-A, SW-A, W-A",null,null,null,null,null,null,null,null,null,"FWG-A, PW-A, PWG-A, RF-A, RFG-A, SR-A, SRG-A"]
[null,null,null,"non recessed =",{"$f":"IF(OR(C4=1, C4=2, C4=8, C4=9, C4=12, C4=13), TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,"recessed = ",{"$f":"IF(E39=TRUE,FALSE,TRUE)","v":false}]
[null,null,null,null,"door sum = lh choice plus rh choice",null,null,null,null,null,null,null,null,null,"door sum = lh choice plus rh choice"]
[null,null,null,"3 or 4","3 & 4",null,null,"5 or 6","5 & 6",null,null,null,null,"3 or 4","3 & 4",null,null,"5 or 6","5 & 6"]
[null,null,null,3,6,null,null,4,8,null,null,null,null,3,6,null,null,4,8]
[null,20,1,0.94,0.88,null,1,0.82,0.65,null,null,20,1,0.97499999999999998,0.95,null,1,0.92500000000000004,0.85]
[null,24,2,0.95,0.91,null,2,0.86,0.72,null,null,24,2,0.98,0.96,null,2,0.94,0.88]
[null,28,3,0.96,0.92,null,3,0.89,0.77,null,null,28,3,0.98199999999999998,0.96799999999999997,null,3,0.94799999999999995,0.90200000000000002]
[null,32,4,0.97,0.94,null,4,0.89,0.8,null,null,32,4,0.98499999999999999,0.97199999999999998,null,4,0.95499999999999996,0.91800000000000004]
[null,36,5,0.97,0.94,null,5,0.92,0.83,null,null,36,5,0.98799999999999999,0.97499999999999998,null,5,0.96199999999999997,0.92500000000000004]
[null,40,6,0.97,0.95,null,6,0.92,0.85,null,null,40,6,0.99,0.97799999999999998,null,6,0.97,0.93200000000000005]
[null,44,7,0.98,0.95,null,7,0.93,0.86,null,null,44,7,0.99,0.98,null,7,0.97,0.94]
[null,48,8,0.98,0.96,null,8,0.94,0.88,null,null,48,8,0.99,0.98199999999999998,null,8,0.97,0.94799999999999995]
[null,52,9,0.98,0.96,null,9,0.95,0.89,null,null,52,9,0.99199999999999999,0.98499999999999999,null,9,0.97799999999999998,0.95499999999999996]
[null,56,10,0.98,0.96,null,10,0.95,0.89,null,null,56,10,0.99199999999999999,0.98499999999999999,null,10,0.97799999999999998,0.95499999999999996]
[null,60,11,0.98,0.97,null,11,0.95,0.9,null,null,60,11,0.99199999999999999,0.98499999999999999,null,11,0.97799999999999998,0.95499999999999996]
[null,64,12,0.98,0.97,null,12,0.95,0.91,null,null,64,12,0.99199999999999999,0.98799999999999999,null,12,0.97799999999999998,0.96199999999999997]
[]
[null,null,"3/4 door sum ",{"$f":"IF(D19=TRUE,0,IF(C23=TRUE,3,0))+IF(D20=TRUE,0,IF(F23=TRUE,3,0))","v":0},null,null,"5/6 door sum ",{"$f":"IF(D19=TRUE,0,IF(C25=TRUE,4,0))+IF(D20=TRUE,0,IF(F25=TRUE,4,0))","v":0}]
[null,null,"temp 3/4 door derate 1 =",{"$f":"IF(OR(D56=3, D56=6),HLOOKUP(D56,D42:E54,I4+1,FALSE),1)","v":1},null,null,null,null,null,null,null,null,"temp 3/4 door derate 2 =",{"$f":"IF(OR(D56=3, D56=6),HLOOKUP(D56,N42:O54,I4+1,FALSE),1)","v":1}]
[null,null,"temp 5/6 door derate 1 =",{"$f":"IF(OR(H56=4, H56=8),HLOOKUP(H56,H42:I54,I4+1,FALSE),1)","v":1},null,null,null,null,null,null,null,null,"temp 5/6 door derate 2 =",{"$f":"IF(OR(H56=4, H56=8),HLOOKUP(H56,R42:S54,I4+1,FALSE),1)","v":1}]
[null,null,"temp combined derate 1 =",{"$f":"D57*D58","v":1},null,null,null,null,null,null,null,null,"temp combined derate 2 =",{"$f":"N57*N58","v":1}]
[null,null,null,null,null,null,"Final access door derate factor =",{"$f":"IF(E39=TRUE,D59,IF(O39=TRUE,N59,1))","v":1}]
[]
[]
[]
[]
["type","Access door error conditions"]
[1,{"$f":"IF(AND(C4=1,OR(C25=TRUE,F25=TRUE,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE)))),1,0)","v":0},"if type = FS-A and ((door = 1, 2 and height =20 or less) or  door = 5 or 6) then error"]
[2,{"$f":"IF(AND(C4=2,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = FSG-A and (door = 1, 2 and height =20 or less)  then error"]
[3,{"$f":"IF(AND(C4=3,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = FWG-A and (door = 1, 2 and height =20 or less)  then error"]
[4,{"$f":"IF(AND(C4=4,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = PW-A and (door = 1, 2 and height =20 or less)  then error"]
[5,{"$f":"IF(AND(C4=5,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = PWG-A and (door = 1, 2 and height =20 or less)  then error"]
[6,{"$f":"IF(AND(C4=6,OR(C25=TRUE,F25=TRUE,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE)))),1,0)","v":0},"if type = RF-A and ((door = 1, 2 and height =20 or less) or  door = 5 or 6) then error"]
[7,{"$f":"IF(AND(C4=7,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = RFG-A and (door = 1, 2 and height =20 or less)  then error"]
[8,{"$f":"IF(AND(C4=8,OR(C25=TRUE,F25=TRUE,OR(AND(L4<3,C23=TRUE),AND(L4<3,F23=TRUE),AND(L4=3,OR(F4=2,F4=3))))),1,0)","v":0},"if type =SF-A and (door =3,4 and (height = 18, 20 (or depth = 6,8 and height = 24)) or door =5,6) then error"]
[9,{"$f":"IF(AND(C4=9,OR(AND(L4<3,C23=TRUE),AND(L4<3,F23=TRUE),AND(L4=3,OR(F4=2,F4=3)))),1,0)","v":0},"if type =SFG-A and door = 3,4 and (height = 18, 20 (or depth = 6,8 and height = 24)) then error"]
[10,{"$f":"IF(AND(C4=10,OR(C25=TRUE,F25=TRUE,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE)))),1,0)","v":0},"if type = SR-A and ((door = 1, 2 and height =18 or less) or  door = 5 or 6) then error"]
[11,{"$f":"IF(AND(C4=11,OR(AND(L4<3,C24=TRUE),AND(L4<3,F24=TRUE))),1,0)","v":0},"if type = SRG-A and (door = 1, 2 and height =18 or less)  then error"]
[12,{"$f":"IF(AND(C4=12,OR(AND(L4<4,C23=TRUE),AND(L4<4,F23=TRUE),AND(L4=1,C25=TRUE),AND(L4=1,F25=TRUE))),1,0)","v":0},"if type =SW-A and (door = 3,4 and height = 14, 18, 20) or (door = 5,6 and height = 14) then error"]
[13,{"$f":"IF(AND(C4=13,OR(AND(L4<4,C24=TRUE),AND(L4<4,F24=TRUE),AND(L4=1,C25=TRUE),AND(L4=1,F25=TRUE))),1,0)","v":0},"if type = W-A and (door = 1,2 and height = 14, 18, 20) or (door = 5, 6 and height = 14) then error"]
["sum",{"$f":"SUM(B66:B78)","v":0},{"$f":"IF(B79<>0,\"Access Door location chosen is unavailable\",\"\")","v":""}]
[null,"if sum <> 0 then display invalid door location message"]
[]
[]
[null,"End Pocket error conditions"]
[null,"length",null,null,{"$f":"INDEX(H4:H15,I4)","v":20}]
[null,"type",null,null,{"$f":"INDEX(B4:B16,C4)","v":"FS-A"}]
[null,"# end pockets selected",null,null,{"$f":"IF(AND(D19=TRUE,D20=TRUE),2,IF(OR(D19=TRUE,D20=TRUE),1,0))","v":0}]
[null,"check if SR-A or RF-A",null,null,{"$f":"IF(OR(E85=\"SR-A\",E85=\"RF-A\"),\"TRUE\",\"FALSE\")","v":"FALSE"}]
[]
[null,null,"Conditions"]
[null,{"$f":"AND(E84=64,E87=\"FALSE\",E86=2)","v":false},"if length = 64 and type <> SR-A  or RF-A and 2 end pockets selected then \"One End Pocket Maximum\"  else no error message"]
[null,{"$f":"AND(E84=64,E87=\"TRUE\",E86>0)","v":false},"if length = 64 and type = SR-A or RF-A  then \"End Pockets Not Available\" else no error message"]
[null,{"$f":"AND(E84=60,E87=\"TRUE\",E86=2)","v":false},"if length = 60 and type = SR-A or RF-A and 2 end pockets then \"One End Pocket Maximum\"  else no error message"]
[null,{"$f":"IF(AND(E84<>64,E87<>\"TRUE\"),\"TRUE\",\"FALSE\")","v":"TRUE"},"if length <> 64 and type <> SR-A or RF-A then no error message"]
[]
[null,"error message = ",null,{"$f":" IF(OR(B90=TRUE,B92=TRUE),\"One End Pocket Maximum\", IF(B91=TRUE,\"End Pockets Not Available\",\"\"))","v":""}]

{"sheet":"Rate Convector","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,2,1,11],[26,2,26,5],[5,7,5,10],[3,7,3,10],[7,7,7,10],[13,7,13,11],[9,2,9,5],[16,2,16,5],[20,2,20,5],[3,2,3,4],[22,7,23,11],[13,2,13,5]]}
[null,null,"Mestek Convector Rating Spreadsheet"]
[]
[]
[null,null,"Convector  Selection Inputs",null,null,null,null,"End Pocket Selection"]
[null,null,"Type"]
[null,null,"Depth",null,null,null,null,{"$f":"'Hidden Controls'!D95","v":""}]
[null,null,"Length"]
[null,null,"Height",null,null,null,null,"Access Door Selection"]
[]
["Cell",null,"Standard Condition   215°F @ 65°F EAT"]
["Legend",null,null,"Heat Capacity",{"$f":"MROUND(E12*240,5)","v":2230},"BTUH"]
["Input",null,null,"Heat Capacity",{"$f":"'Hidden Data'!L56*L16*L17","v":9.3000000000000007},"EDR",null,{"$f":"IF('Hidden Controls'!B79=1,\"Access Door location chosen is unavailable\",\"\")","v":""}]
["Output"]
["Reference",null,"Common Condition",null,null,null,null,"Applied Deratings"]
[null,null,null,"Altitude",0,"Feet",null,null,null,null,"Altitude derate factor",{"$f":"'Hidden Data'!F279","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Inlet Grille derate factor",{"$f":"'Hidden Controls'!H35","v":1}]
[null,null,"Steam Ratings",null,null,null,null,null,null,null,"Access Door derate factor",{"$f":"'Hidden Controls'!H60","v":1}]
[null,null,null,"Steam Pressure",0.89900000000000002,"PSIG",null,null,null,null,"Steam Pressure correction factor",{"$f":"'Hidden Data'!L68","v":1}]
[null,null,null,"Steam Unit Capacity",{"$f":"E11*L18*L15","v":2230},"BTUH",null,null,null,null,"Water/Air Temp correction factor",{"$f":"'Hidden Data'!C90","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Fluid Temp Drop correction factor",{"$f":"'Hidden Data'!F267","v":1}]
[null,null,"Hot Water Ratings",null,null,null,null,null,null,null,"Glycol correction factor",{"$f":"'Hidden Data'!Q131","v":1}]
[null,null,null,"Entering Air Temp",65]
[null,null,"Fluid",null,null,null,null,{"$f":"IF('Hidden Controls'!L20=3,\"Ethylene Glycol is NOT recognized or approved for use by USDA and other health agencies.\",\"\")","v":""}]
[null,null,null,"Average Fluid Temp",215,"°F"]
[null,null,null,"Fluid Temp Drop",20,"°F"]
["MDG",null,null," Glycol",0,"%",null,{"$f":"IF(H27=\"\",\"Flow is above minimum flow limit\",\"\")","v":"Flow is above minimum flow limit"}]
["11/2019",null,{"$f":"IF(AND(E26<>0,'Hidden Controls'!L20=1),\"Glycol & Fluid Mismatch - Glycol Ignored\",\"\")","v":""},null,null,null,null,{"$f":"IF(E29<J28,\"Warning - Laminar Flow\",\"\")","v":""}]
[null,null,"Water Unit Capacity",null,{"$f":"E11*L19*L20*L21*L15","v":2230},"BTUH",null,null,"Min. Flow Limit =",{"$f":"'Hidden Data'!G252","v":0.14370045678081256},"GPM"]
[null,null,null,"Fluid Flow Rate",{"$f":"E28/(500*E25)","v":0.223},"GPM",null,{"$f":"IF('Hidden Data'!C164=1,\"* flow rate exceeds highest flow rate on pressure\",\"\")","v":""}]
[null,null,null,"Pressure Loss",{"$f":"'Hidden Data'!C163","v":3.9247999999999998E-2},"FT H2O",null,{"$f":"IF('Hidden Data'!C164=1,\"loss chart - unable to calculate\",\"\")","v":""}]